--  p_GetTACACSTransactionDetails 'TACAS5'
use METAImage
go
IF OBJECT_ID('dbo.p_GetTACACSTransactionDetails') IS NOT NULL
BEGIN
 DROP PROCEDURE dbo.p_GetTACACSTransactionDetails
    IF OBJECT_ID('dbo.p_GetTACACSTransactionDetails') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.p_GetTACACSTransactionDetails >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.p_GetTACACSTransactionDetails >>>'
END
go

create proc p_GetTACACSTransactionDetails
(
        @TransactionID                  varchar(50)     -- TransactionID
	
) 
as begin
        -- declares
        declare @Msg            varchar(255)    -- last error message
        declare @ErrVal         int             -- last error number   
        select @ErrVal=0
        SELECT * from TACACSRequests WHERE TransactionID = @TransactionID

End

go
/*
EXEC sp_procxmode 'dbo.p_GetTACACSTransactionDetails','unchained'
go
*/
IF OBJECT_ID('dbo.p_GetTACACSTransactionDetails') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.p_GetTACACSTransactionDetails >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.p_GetTACACSTransactionDetails >>>'
go
--GRANT EXECUTE ON dbo.p_GetTACACSTransactionDetails TO public
--go